Release 10.1A: OpenEdge Data Management:
SQL Reference

CURDATE

Returns the current date as a DATE value. This function takes no arguments.

Syntax

CURDATE ( )

Example

The following example shows how to use the CURDATE function:

INSERT INTO objects (object_owner, object_id, create_date) VALUES (USER, 1001, CURDATE()) ;

Note

SQL statements can refer to CURDATE anywhere they can refer to a DATE expression.

Compatibility

ODBC compatible

See also

SYSDATE function